|
|
| Author |
Thread Statistics | Show CCP posts - 10 post(s) |
Corraidhin Farsaidh
Farsaidh's Freeborn
1518
   |
Posted - 2015.08.10 09:17:25 -
[1] - Quote
It's always interesting to see others peoples pain in these situations, mainly because misery loves company :D
I'd suggest replacing the databases with Oracle and hiring me to build them for you...and nuke the M$ stuff from orbit, it's the only way to be sure... |
Corraidhin Farsaidh
Farsaidh's Freeborn
1518
|
Posted - 2015.08.10 13:01:50 -
[2] - Quote
CCP Goliath wrote:Dradis Aulmais wrote:Sounds like Ghost in the machine.TQ is a very unique system. 12 years old, reborn several times. Code here code there, its own little ecosystem. Its like the ultimate Capsleer. I kind of love this analogy 
I prefer my analogy of M$ software being a xenomorph that clamps itself to your face before infesting you with a parasite that eats you from the inside.
Then again my view may be somewhat tainted by having bought a laptop with Windows 8 pre-installed a few years back...someone pass me an m41a pulse rifle... |
Corraidhin Farsaidh
Farsaidh's Freeborn
1528
|
Posted - 2015.08.11 22:51:06 -
[3] - Quote
CCP DeNormalized wrote:Corraidhin Farsaidh wrote:It's always interesting to see others peoples pain in these situations, mainly because misery loves company :D
I'd suggest replacing the databases with Oracle and hiring me to build them for you...and nuke the M$ stuff from orbit, it's the only way to be sure... hmmm, I'd rather we not go that route, thanks :)
I'm sensing a vested interest... |
Corraidhin Farsaidh
Farsaidh's Freeborn
1553
|
Posted - 2015.08.17 08:41:25 -
[4] - Quote
CCP DeNormalized wrote:Cor'len wrote:
I expect it was also a case of "We can't reproduce this reliably on our test servers, so we have to debug it in production". I think it was somewhat unclear whether the DB was modified in a way which would've prevented the rollback, and as Masterplan said, a DB restore takes time - I seem to recall a figure of multiple hours.
CCP: Thanks for fixing it, for the skillpoints, and also for the well-written report on the pizza. <3
We take full backups prior to each DT, so it would of been a full backup in no recovery mode plus a few transaction log backups to bring us to just past DT. Roughly 3 hours for the 3 TB+ restore. Funny enough we can restore faster in our test env. due to having a massive pool of SAS disks (100's) on the SAN vs. the small pool of SSD disks that the TQ DB uses :)
Pssst...you know that Oracle can do incremental backups whilst the DB is still up and running...would take significantly less time that 3 hours..
On a completely unrelated note I know lots about Oracle RMAN backup and recovery... |
Corraidhin Farsaidh
Farsaidh's Freeborn
1553
|
Posted - 2015.08.17 08:44:15 -
[5] - Quote
KenFlorian wrote:CCP DeNormalized wrote:Actually, Oracle RAC is super sexy stuff and I'd love to get some experience with it!
it kicks the pants off SQL Server's offerings in this regard (although I've never used it and perhaps it's junk - but it sounds awesome!) Actually, I am the HR guy for a company that works on Netezza. 6th normal form on many-terabyte sized data? No problem.
Oracle RAC works very well indeed as long as it is configured correctly (just like anything else :D ). If you want a nice stable cluster with great backup options (RMAN is free btw) You should really look at Oracle
And nice Oracle DBA's.... |
|
|
| |
|